package com.muli.muwai.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.muli.muwai.entity.IntfFinBuget;
import org.apache.ibatis.annotations.Delete;
import org.springframework.stereotype.Repository;

@Repository
public interface FinancingBudgetMapper extends BaseMapper<IntfFinBuget> {
    @Delete("DELETE  FROM `intf_fin_buget` where jan !=0 or jan=0")
    int deleteJan();

    @Delete("DELETE  FROM `intf_fin_buget` where feb !=0 or feb=0")
    int deleteFeb();

    @Delete("DELETE  FROM `intf_fin_buget` where mar !=0 or mar=0")
    int deleteMar();

    @Delete("DELETE  FROM `intf_fin_buget` where apr !=0 or apr=0")
    int deleteApr();

    @Delete("DELETE  FROM `intf_fin_buget` where may !=0 or may=0")
    int deleteMay();

    @Delete("DELETE  FROM `intf_fin_buget` where jun !=0 or jun=0")
    int deleteJun();

    @Delete("DELETE  FROM `intf_fin_buget` where jul !=0 or jul=0")
    int deleteJul();

    @Delete("DELETE  FROM `intf_fin_buget` where aug !=0 or aug=0")
    int deleteAug();

    @Delete("DELETE  FROM `intf_fin_buget` where sep !=0 or sep=0")
    int deleteSep();

    @Delete("DELETE  FROM `intf_fin_buget` where oct !=0 or oct=0")
    int deleteOct();

    @Delete("DELETE  FROM `intf_fin_buget` where nov !=0 or nov=0")
    int deleteNov();

    @Delete("DELETE  FROM `intf_fin_buget` where dece !=0 or dece=0")
    int deleteDec();
}
